<?php 
namespace Admin\Model;

/**
 * 店铺类
 */
class ShopsModel extends BaseModel {
	/**
	 * 分页查询
	 */
	public function queryByPage() {
		$m = M('shops');
       
	 	$sql = "select shopId,shopSn,shopName,u.userName,shopAtive,shopStatus,gc.catName from __PREFIX__shops s,__PREFIX__users u ,__PREFIX__goods_cats gc 
	 	     where gc.catId=s.goodsCatId1 and s.userId=u.userId and shopStatus=1 and shopFlag=1 ";
	 
	 	$sql.=" order by shopId desc";
		return $m->pageQuery($sql);
	}








}


 ?>